# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 localhost
# Database:             tyms
# Server version:       5.0.27-community
# Server OS:            Win32
# HeidiSQL version:     3.0 RC2 Revision: 55
# --------------------------------------------------------

#
# Dumping data for table 'customer'
#


#
# Dumping data for table 'customer_company'
#


#
# Dumping data for table 'employee'
#


#
# Dumping data for table 'function'
#
/*! set NAMES 'utf8'*/
/*!40000 ALTER TABLE function DISABLE KEYS */;
LOCK TABLES function WRITE;
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('1','基础数据维护',NULL,'','','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('102','员工信息','1','employee/employee.action','/employee','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('103','客户信息','1','customer/customer.action','/permission','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('104','角色维护','1','role/role.action','/permission','');
UNLOCK TABLES;
/*!40000 ALTER TABLE function ENABLE KEYS */;

#
# Dumping data for table 'order'
#


#
# Dumping data for table 'permission'
#


#
# Dumping data for table 'role'
#

/*!40000 ALTER TABLE role DISABLE KEYS */;
LOCK TABLES role WRITE;
INSERT INTO role (ROLE_ID, ROLE_NAME, IS_ADMIN) VALUES ('1','管理员','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE role ENABLE KEYS */;

#
# Dumping data for table 'user'
#

/*!40000 ALTER TABLE user DISABLE KEYS */;
LOCK TABLES user WRITE;
INSERT INTO user (USER_ID, LOGIN_ID, LOGIN_PWD, CREATED_DATE, LAST_MODIFIED, ROLE_ID) VALUES ('1','admin',NULL,'1899-12-30 19:00:00','1899-12-30 19:00:00','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE user ENABLE KEYS */;
